package com.atguigu.mapper;

import com.atguigu.Pojo.Employee;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author Cheng-02
 * @version V1.0
 * @Package com.atguigu.mapper
 * @date 2024/4/25 下午8:42
 */
public interface Employeemapper {
    //根据员工姓名和工资查询员工的信息
    List<Employee> query(@Param("name") String name, @Param("salary") Double salary);

    //根据员工id更新员工的数据  要求name和salary不为空才更新
    int update(Employee employee);

    List<Employee> queryChoose(@Param("name") String name, @Param("salary") Double salary);

    //根据id批量查询
    List<Employee> queryBatch(@Param("ids") List<Integer> ids);

    int deleteBatch(@Param("ids")List<Integer> ids);

    int insertBatch(@Param("list")List<Employee> employeeList);

    int updateBatch(@Param("list")List<Employee> employeeList);


}
